Model Table ACTIVITY

This model dimension represents project related activities and is based on the IFS Cloud dimension DIM_ACTIVITY. All models that refer to this dimension will have the attributes and hierarchies as described below.

Natural parents are Project Id and Sub Project Id.

Attributes

Attribute Description (where applicable)
ActivityBuilt as PROJECT_ID + ' - ' + SUB_PROJECT_ID + ' - ' + ACTIVITY_NO + ' - ' + ACTIVITY_DESCRIPTION
Activity CodeThe code of the dimension built as ACTIVITY_SEQ (activity sequence number)
Activity DescrRepresens the activity description (ACTIVITY_DESCRIPTION)
Activity NoRepresents the activity number (ACTIVITY_NO)
Activity No DescriptionRepresents the activity number description as ACTIVITY_NO + ' - ' + ACTIVITY_DESCRIPTION
Activity ResponsibleRepresents the name of the activity responsible (RESPONSIBLE_NAME)
Activity ShortNameRepresents the short name of the activity (ACTIVITY_SHORT_NAME)
Activity StatusRepresents the status of the activity (STATUS)
Project IdRepresents the project id that the activit is connected to (PROJECT_ID)
Project Subproject IdRepresents a string identity of the parent project and sub project defined as PROJECT_ID + '^' + SUB_PROJECT_ID
Sub Project IdRepresents the sub project id that the activity is connected to (SUB_PROJECT_ID)

Hierarchies

Hierarchy Level
Project Hierarchy
Project Id
Sub Project Id
Activity

USED BY MODEL(S)

Model Name
Production Performance

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
ACTIVITYDIM_ACTIVITY_TMDIM_ACTIVITY_BIDIM_ACTIVITYOn Line